package com.bjwl.wybx.mapper;

import com.bjwl.wybx.VO.UserLoginVO;
import com.bjwl.wybx.entity.User;
import org.apache.ibatis.annotations.Select;


public interface UserMapper {
    //通过账户和密码查询
    @Select("select * from sys_user where u_id=#{u_id} and u_pwd=#{u_pwd}")
    User queryByUIdAndUPwd(UserLoginVO userLoginVO);

    //在ur表中查询ro_id
    @Select("select ro_id from sys_ur where u_id=#{u_id}")
    Integer queryRoIdByuId(String u_id);

    //通过用户id查询用户名
    @Select("select * from sys_user")
    User queryUNameByUId(String u_id);
}
